﻿namespace Sidvall.Office
{
	public interface IWorksheet
	{
		IWorksheetDisplayOptions DisplayOptions { get; }
		string Name { get; set; }
		IWorksheetShapeCollection Shapes { get; }

		string GetText(int rowIndex, int columnIndex);
		string GetText(int rowIndex, int columnIndex, TextFormatMode textFormatMode);
		object GetValue(int rowIndex, int columnIndex);
		IWorksheetCell GetWorksheetCell(int rowIndex, int columnIndex);
		IWorksheetColumn GetWorksheetColumn(int columnIndex);
		IWorksheetRow GetWorksheetRow(int rowIndex);

		void MoveToIndex(int index);
		void SetValue(int rowIndex, int columnIndex, object value);
	}
}
